package cn.wolfcode.shop.cloud.mapper;

import cn.wolfcode.shop.cloud.domain.Good;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.SelectProvider;

import java.util.ArrayList;
import java.util.List;
@Mapper
public interface GoodMapper {
    @SelectProvider(type = GoodQuery.class,method = "queryGoods")
    List<Good> queryGoods(@Param("ids") ArrayList ids);

class GoodQuery{
    //select*from t_goods where id in (1,2,3,4,5,6)
    public String queryGoods(@Param("ids") ArrayList ids){
        StringBuilder sb=new StringBuilder();
        sb.append("select * from t_goods where id in ( ");
        for (int i = 0; i < ids.size(); i++) {
            if(i !=0){
                sb.append(",");
            }
            sb.append(ids.get(i));
        }
        sb.append(")");
        return  sb.toString();
    }

}


}
